package cn.edu.jgsu.jgsuchat.mapper;

import cn.edu.jgsu.jgsuchat.pojo.databasePojo.Friends;
import cn.edu.jgsu.jgsuchat.pojo.databasePojo.User;
import cn.edu.jgsu.jgsuchat.pojo.customPojo.SelectFriendsByUserId;
//import org.apache.ibatis.annotations.Mapper;
//import org.apache.ibatis.annotations.Select;

import java.util.List;


public interface UserDao {
  /*  @Select("select user.id as myId,user.name myName,f.friend_id as friendId,a.name as friendName\n" +
            "\n" +
            "from user\n" +
            "join friends f on user.id = f.user_id\n" +
            "join user a on f.friend_id=a.id\n" +
            "where user.id=#{userid}")
    public List<SelectFriendsByUserId> selectFriendsByUserId(int userid);
    @Select("select id\n" +
            "from user;")
    public List<User> selectAllUsersId();
    @Select("select friend_id\n" +
            "from friends\n" +
            "where  user_id =#{id};")
    public List<Friends> selectFriendsIdByUserId(int id);*/
}
